IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spLetterHeaderAndFooter_Update')
	BEGIN
		PRINT 'Dropping Procedure spLetterHeaderAndFooter_Update'
		DROP  Procedure  spLetterHeaderAndFooter_Update
	END

GO

PRINT 'Creating Procedure spLetterHeaderAndFooter_Update'
GO
Create Procedure dbo.spLetterHeaderAndFooter_Update
	( 	  
		@HeaderFont varchar(50), 
		@HeaderFontSize decimal, 
		@HeaderFontStyle varchar(50), 
		@HeaderText varchar(500), 
		@HeaderImagePath varchar(50), 
		@FooterFont varchar(50), 
		@FooterFontSize decimal, 
		@FooterFontStyle varchar(50), 
		@FooterText varchar(500)
	)
AS
  /* 
    ------------------------------------------------------------------------------
    - Change History
    - --------------
    - Date          Description
    ------------------------------------------------------------------------------
    - 10/23/2007    Initial version Updated
    ------------------------------------------------------------------------------
  */

	-- Declare the required variables

	-- Update the required new record
	UPDATE LetterHeaderAndFooter
	SET
		HeaderFontSize = @HeaderFontSize, 
		HeaderFontStyle = @HeaderFontStyle, 
		HeaderText = @HeaderText, 
		HeaderImagePath = @HeaderImagePath, 
		FooterFont = @FooterFont, 
		FooterFontSize = @FooterFontSize, 
		FooterFontStyle = @FooterFontStyle, 
		FooterText = @FooterText		

	-- Return to calling method
	RETURN
	
GO
